SUPPORT / SAMPLES & SAS NOTES
Problem Note 67750: Inserting data into a Google BigQuery table using the FEDSQL procedure might result in errors
 |  |  |  |  |
When you use the FEDSQL procedure and it involves inserting data into a Google BigQuery table, you might receive an error. Here are some of the errors that have been encountered due to this issue:
ERROR: Error: googleapi: Error 400: Syntax error: Expected ")" but got keyword DESC at [1:214], invalidQuery
ERROR: Error: 1 row insertion failed (insertion of row [insertID: "XFr8Js3lVteMwCsHO9VuFfJSwyP"; insertIndex: 0] failed with error:
{Location: "ID"; Message: "no such field."; Reason: "invalid"})
{Location: "ID"; Message: "no such field."; Reason: "invalid"})
The issue occurs when the data being inserted contains a backslash (\) and the SCANSTRINGCOLUMNS=YES option is specified.
The workaround is to use SCANSTRINGCOLUMNS=NO.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.41 | 9.43 | 9.4 TS1M6 | 9.4 TS1M8 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | 2020.1.1 | 2020.1.4 | Viya | Viya |